package com.example.personnel_oa.mapper;
//数据访问层
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.comment_oa.pojos.Positive;
import com.example.comment_oa.pojos.SysEmployee;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;


import java.util.List;


/**
* @author HUAWEI
* @description 针对表【positive】的数据库操作Mapper
* @createDate 2022-10-18 15:31:47
* @Entity personnel_oa.pojos.Positive
*/
@Mapper//识别他为mybatis的mapper接口
public interface PositiveMapper extends BaseMapper<Positive> {
        @Select("select * from positive")//利用注解开发就不需要xml映射文件
        public List<Positive> Methods_b ();
        public List<SysEmployee> allPositive();
        public List<Positive> allcontract(int pid);
        //新增转正申请数据
        int insertadd(Positive positive);
        //根据输入框中的内容做模糊查询
        List<Positive> allpos(Positive positive);
        //根据工号查询审批数据详情
        Positive posGonghao(String posGposBianhaoonghao);
        //转正审批成功
        int posState(String posName,String posBianhao);
        //转正审批失败
        int posStates(String posName,String posBianhao);
}
